FirstDateOfDayInYear

Syntax:

FirstDateOfDayInYear(dateexpr, NumZ{day})

Description:
Returns the date of the first instance of the specified day in the year of the date specified. For example, this function could return the date of the first Monday of next year .

Parameter Description

dateexpr A the date to be used when determining the first instance of the day.

NumZ{day} The day to check for.

ò vbSunday (1) - Sunday

ò vbMonday (2) - Monday

ò vbTuesday (3) - Tuesday

ò vbWednesday (4) - Wednesday

ò vbThursday (5) - Thursday

ò vbFriday (6) - Friday

ò vbSaturday (7) - Saturday

Example:

Sub Main
'return the date of the first Sunday of this year.
firstSundayofthisyear = FirstDateOfDayInYear(Now(),1)

'return the date of the first Monday of next year.
firstMondayofnextyear = FirstDateOfDayInQuarter(DateAdd(1, "yyyy" ,Now()),2)

End Sub